package com.opo5.logisticsmanagement.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.opo5.logisticsmanagement.Vo.MaterialVo;
import com.opo5.logisticsmanagement.domain.PlanList;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface PlanListDao extends BaseMapper<PlanList> {
    @Select("SELECT p.wastedescribe,p.innum,p.outnum,d.date,p.projectname\n" +
            "FROM tbs_plan_list p\n" +
            "JOIN tbs_wu_plan w\n" +
            "ON w.id=p.id\n" +
            "JOIN tbs_date d\n" +
            "ON d.id=w.id")
    Page<MaterialVo> getElectricity(Page<MaterialVo> iPage);
}
